Embed Link with pivot using filter
Embed Link with pivot using filter: This video contains how to use Embed Link with pivot using filter.
- In this Document you will learn to Create a dashboard and add a Card chart widget and Table widget. You will learn create embed link and how to connect embed link with one dashboard to another dashboard and filter detail dashboard with global filter parameters.
[note: to apply global filters, parameterized dataset should be used in detail dashboard]
Click on hamburger icon.
Click on (+) icon, from visualization Tab.
The Create Dashboard Dialog box will pop up on screen. Enter Dashboard Name as shown in Figure.
Click on Create After entering Dashboard Name in dialog box.
You will see an Empty Dashboard, As shown in figure below:
From Right Vertical Menu Select the Pivot Widget icon.
The Edit menu box appears as you click on Pivot chart icon. And a widget gets added in content place automatically in dashboard, As shown in Figure below:
Enter Following details in Pivot:
Type: Table
Dataset: Salesb.ds
Drag and drop country in rows and productLine in Columns.
Drag and drop country in Values.
Fill above details in edit box, As Shown in figure;
Click on Save and Exit.
Pivot widget is shown in Figure Below:
Create a New Dashboard and give Name Detailed Data of the dashboard, As shown in figure Below:
From Right Vertical Menu Select the Table Widget icon.
The Edit menu box appears as you click on Table Widget icon. And a widget gets added in content place automatically in dashboard, As shown in Figure below:
Enter Following details in General Property:
Dataset: Parameter.ds
In Dataset Column Select All the Field.
Fill above details in edit box, As Shown in figure below;
Click on Preview and Save and Exit, As shown in figure below:
Create a New filter in Detailed 5 dashboard.
Give the Name Country, As shown in figure Below:
Click on Save.
In Country filter Event select On Change.
Click on Setting icon of country Filter.
Enter Following details in Filter Widget:
Source: Dataset
Dataset: Salesb.ds
Column Name: Country
Toggle Save Filter and set Default when Clear.
Fill above details, As shown in figure Below:
Click on Link Filter and Widget Property.
Enter Following details in Link Filter and Widget Property.
Layer: Layer 1
Tabs: Event Check
Widget: Table Widget 1
Select the country in Available Column.
Fill above details as shown in Figure Below:
Click on Save and Exit.
Create another New filter in Detailed 5 dashboard.
Give the Name Product Line of the filter.
In Product Line filter Event select On Change
Click on Setting icon of Product Line Filter.
Enter Following details in Filter Widget:
Source: Dataset
Dataset: Salesb.ds
Column Name: product Line
Toggle Save Filter and set Default when Clear.
Fill above details, As shown in figure Below:
Click on Link Filter and Widget Property.
Enter Following details in Link Filter and Widget Property.
Layer: Layer 1
Tabs: Event Check
Widget: Table Widget 1
Select the Product Line in Available Column.
Fill above details as shown in Figure Below:
Click on Save and Exit.
Click on Embed icon of the Detailed Data Dashboard, As shown in Figure Below:
Copy the Link of Internal Embed in Embed.
Click on Cancel.
Open the Pivot Summery Dashboard 5 in Edit mode.
Enter Following details in Pivot Property:
Hyperlink: Custom Link
Link:
http://localhost:8080/aiv/embed/internal/aivHubInternalEmbed/a_i__214&a_n__Detailed5&a_as__dashboards&a_af__true/Country___{{country}}&Product Line___{{productLine}}
Fill above details as shown in figure below:
Click on Preview Save and Exit.
Now Click on Preview mode.
Click on Classic car in Column and Canada in Raw.
It will redirect on Detailed Dashboard 5, As shown in figure Below: